Organisation Interface Table

This extract file interface handles records for each organisation to be created or updated in the CXPClosed Customer Experience Platform, or CXP, is MDS Global's self-service app that allows business customers to manage their own accounts and subscriptions. database.

Data loaded via this interface is primarily bound for the ORGANISATION and ORGANISATION_DATA_SOURCE CXP Admin schema tables.

External table name

Schema

Mapped file

organisation _Interface

Staging

organisation.dat

 

Organisation interface table fields

Column Heading

Type

Length

Description

EXTERNAL_ORGANISATION_ID

VarChar2

40

Identifier signifying the owner of an organisation unit hierarchy. The organisation provides a way to collectively group organisation units together to allow the sharing of such things as filter sets and address books. It is important to note that EXTERNAL_ORGANISATION_ID is considered to apply universally, spanning all potential data source feeds. That is to say that if the same EXTERNAL_ORGANISATION_ID value is fed in to a CXP environment for customers from two different data sources, then those two customers and their hierarchies will be considered to be part of the same organisation and by assigned the same ORGANISATION_ID. Membership of an organisation then grants users that can access hierarchy nodes belonging to that organisation, the ability to share public resources such as address books that are stored against the organisation. If you are running an environment where customers from different data sources will never need to be associated under a common organisation, then it is highly recommended that you ensure that the EXTERNAL_ORGANISATION_ID values sent to CXP are truly unique (by appending the EXTERNAL_DATA_SOURCE_ID to them for example).
ORGANISATION_NAME VarChar2 100 User friendly name for the current organisation.
CURRENCY_CODE VarChar2 40 A code indicating the currency used by all of the invoices associated with the current organisation and data source combination (where the data source for all of the data in the extract is held in the 'org_load_control.dat' extract file).